Accounts Receivable Tables

Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.

Column Name Column Type Length Default Value Description Enumeration
RcptDetailID int 4      
InvcNum pInvoiceNum 15      
PmtAmt pDecimal 13 0    
Difference pDecimal 13 0    
PmtAmtFgn pDecimal 13 0    
DifferenceFgn pDecimal 13 0    
-*GLAcctGainLoss pGlAcct 40      
-*CalcGainLoss pDecimal 13 0    
RcptHeaderID int 4 0    
DistCode pDistCode 6      
-*InvcExchRate pDecimal 13 -1    
CF xml -1      
ts timestamp 8      
InvcType smallint 2   Invoice Type 1 = Invoice, 5 = Pro Forma
*OrgInvoiceID int 4      
*AdjAmt pDecimal 13 0    
*AdjAmtFgn pDecimal 13 0    
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
RcptHeaderID int 4      
RcptDetailID int 4      
TaxLocID pTaxLoc        
TaxClass tinyint 1      
Level tinyint 1      
TaxAmt pDecimal 13      
TaxAmtFgn pDecimal 13      
Taxable pDecimal 13      
TaxableFgn pDecimal 13      
NonTaxable pDecimal 13      
NonTaxableFgn pDecimal 13      
LiabilityAcct pGlAcct        
ExpenseAcct pGlAcct        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
RcptHeaderID int 4      
DepositID pBatchID 6 '######'    
BankID pBankID 10      
PmtDate datetime 8 getdate()    
PmtAmt pDecimal 13      
AgingPd smallint 2 0 Appy Receipt to Aging Period 0 = Oldest, 1 = Unpaid Finance Charge, 2 = 121+Days, 3 = 91-120 Days, 4 = 61-90 Days, 5 = 31-60 Days, 6 = Current
CheckNum pCheckNum 10      
CustId pCustID 10      
GLAcct pGlAcct 40      
GLPeriod smallint 2 -1    
FiscalYear smallint 2 0    
PmtMethodId nvarchar 10      
CcHolder nvarchar 30      
CcNum nnvarchar 510      
CcExpire datetime 8      
CcAuth nvarchar 10      
Note nvarchar 25      
CurrencyID pCurrency 6      
ExchRate pDecimal 13 -1    
InvcTransID pTransID 8      
InvcAppID nvarchar 2      
SumHistPeriod smallint 2 0    
CcSecCode nvarchar 6      
BankName nvarchar 30      
BankRoutingCode nvarchar 9      
BankAcctNum nnvarchar 510      
SourceId uniqueidentifier 16      
CF xml -1      
ts timestamp 8      
ExtPmtActivityID bigint 8      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
SalesRepID pSalesRep 3      
CustId pCustID 10      
InvcNum pInvoiceNum 15      
InvcDate datetime 8      
PctInvc pDecimal 13 0    
AmtLines pDecimal 13 0    
AmtTax pDecimal 13 0    
AmtFreight pDecimal 13 0    
AmtMisc pDecimal 13 0    
AmtPmt pDecimal 13 0    
AmtCogs pDecimal 13 0    
AmtAdjust pDecimal 13 0    
AmtPrepared pDecimal 13 0    
CommPaid pDecimal 13 0    
CompletedDate datetime 8      
HoldYn bit 1 0    
CommRateDtl pDecimal 13 0    
PctOfDtl tinyint 1 0 Commission Percentage 0 = None, 1 = Sales(Net), 2 = Gross Profit
BasedOnDtl tinyint 1 0 Commission Basis 0 = Booked Sales, 1 = Paid Invoices
PayLines bit 1 -1    
PayTax bit 1 0    
PayFreight bit 1 0    
PayMisc bit 1 0    
AmtInvc pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CustId pCustID 10      
CustName nvarchar 30      
Contact nvarchar 25      
Addr1 nvarchar 30      
Addr2 nvarchar 60      
City nvarchar 30      
Region nvarchar 10      
Country pCountry 6      
PostalCode nvarchar 10      
ShipZone nvarchar 2      
IntlPrefix nvarchar 6      
Phone nvarchar 15      
Fax nvarchar 15      
Attn nvarchar 30      
ClassId nvarchar 6      
SalesRepId1 pSalesRep 3      
SalesRepId2 pSalesRep 3      
Rep1PctInvc pDecimal 13 0    
Rep2PctInvc pDecimal 13 0    
TermsCode pTermsCode 6      
PmtMethod nvarchar 10      
GroupCode nvarchar 1      
StmtInvcCode tinyint 1 -3 Document Type 0 = None, 1 = Statement Only, 2 = Invoice Only, 3 = Both
AcctType tinyint 1 0 Account Type 0 = Open Invoice, 1 = Balance Forward
PriceCode nvarchar 10      
DistCode pDistCode 6      
CalcFinch bit 1 -1    
CreditLimit pDecimal 13 0    
CreditHold bit 1 0    
PartialShip bit 1 -1    
AutoCreditHold bit 1 -1    
TaxLocId pTaxLoc 10      
Taxable bit 1 -1    
TaxExemptId nvarchar 20      
CurrencyId pCurrency 6      
TerrId nvarchar 10      
CcCompYn bit 1 0    
CustLevel nvarchar 10      
Email pEmail 255      
Internet pWeb 255      
NewFinch pDecimal 13 0    
UnpaidFinch pDecimal 13 0    
CurAmtDue pDecimal 13 0    
CurAmtDueFgn pDecimal 13 0    
BalAge1 pDecimal 13 0    
BalAge2 pDecimal 13 0    
BalAge3 pDecimal 13 0    
BalAge4 pDecimal 13 0    
UnapplCredit pDecimal 13 0    
FirstSaleDate datetime 8      
LastSaleDate datetime 8      
LastSaleAmt pDecimal 13 0    
LastSaleInvc pInvoiceNum 15      
LastPayDate datetime 8      
LastPayAmt pDecimal 13 0    
LastPayCheckNum pCheckNum 10      
HighBal pDecimal 13 0    
CreditStatus nvarchar 12      
WebDisplInQtyYn bit 1 0    
Phone1 nvarchar 15      
Phone2 nvarchar 15      
AllowCharge bit 1 0    
Status tinyint 1 0 Customer Status 0 = Active, 1 = Inactive
BillToId pCustID 10      
CF xml -1      
ts timestamp 8      
TaxCertExpDate datetime 8      
*TaxPayerType1 bigint 8      
*TaxPayerType2 bigint 8      
*TaxID1 nvarchar 255      
*TaxID2 nvarchar 255      
*TaxGrpId2 pTaxLoc        
*DUNSNumber nvarchar 9      
Column Name Column Type Length Default Value Description Enumeration
ClassId nvarchar 6      
Desc nvarchar 25      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
SeqNum int 4      
CustId pCustID 10      
PmtMethod nvarchar 10      
Descr nvarchar 30      
CcNum nnvarchar 510      
CcName nvarchar 30      
CcExpire datetime 8      
BankName nvarchar 30      
BankRoutingCode nvarchar 9      
BankAcctNum nnvarchar 510      
MaskValue nvarchar 4      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
DistCode pDistCode 6      
Desc nvarchar 25      
GLAcctReceivables pGlAcct 40      
GLAcctSalesTax pGlAcct 40      
GLAcctFreight pGlAcct 40      
GLAcctMisc pGlAcct 40      
CF xml -1      
ts timestamp 8      
GLAcctDepositReceivables pGlAcct 40      
GLAcctDepositReceivablesContra pGlAcct 40      
Column Name Column Type Length Default Value Description Enumeration
MsgId nvarchar 10      
Desc nvarchar 50      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CustId pCustID 10      
Name varchar 30      
Contact varchar 25      
Attn varchar 30      
Address1 varchar 30      
Address2 varchar 60      
City varchar 30      
Region varchar 10      
Country pCountry 6      
PostalCode varchar 10      
Phone varchar 15      
Fax varchar 15      
Email pEmail 255      
Internet pWeb 255      
CF xml -1      
PostRun pPostRun 14      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
PostRun pPostRun 14      
TransId pTransID 8      
CustId pCustID 10      
InvcNum pInvoiceNum 15      
CredMemNum pInvoiceNum 15      
Amount pDecimal 13      
TermsCode pTermsCode 6      
DistCode pDistCode 6      
FiscalPeriod smallint 2      
FiscalYear smallint 2      
CurrencyId pCurrency 6      
Description nvarchar 30      
ExchRate pDecimal 13      
RecType tinyint 1   Record Type 0 = Invoice, 1 = Credit, 2 = Payment, 3 = Credit Memo
Note nvarchar max      
GLAcctReceivablesDeposit pGlAcct 40      
GLAcctReceivablesDepositContra pGlAcct 40      
PostDate datetime 8      
TransDate datetime 8      
Source tinyint 1   Source 0 = AR, 1 = SO, 2 = SD, 3 = PC
SourceId nvarchar 510      
ProjectName nvarchar 10      
ProjectDescription nvarchar 30      
PhaseId nvarchar 10      
PhaseDescription nvarchar 30      
TaskId nvarchar 10      
TaskDescription nvarchar 30      
PrintOption nvarchar 510      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
TransID pTransID 8      
EntryNum int     Entry Number -1 = Sales Tax, -2 = Freight, -3 = Misc
ItemJob tinyint 1 0 Item / Job Flag 0 = Item, 1 = Job
WhseId pLocID 10      
PartId pItemID 24      
JobId nvarchar 10      
PhaseId nvarchar 10      
JobCompleteYN bit 1 0    
PartType tinyint 1 0 Part Type 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item
Desc nvarchar 35      
AddnlDesc text 16      
CatId nvarchar 2      
TaxClass tinyint 1 0    
AcctCode nvarchar 6      
GLAcctSales pGlAcct 40      
GLAcctCOGS pGlAcct 40      
GLAcctInv pGlAcct 40      
QtyOrdSell pDecimal 13 0    
UnitsSell pUom 5      
UnitsBase pUom 5      
QtyShipSell pDecimal 13 0    
QtyShipBase pDecimal 13 0    
QtyBackordSell pDecimal 13 0    
PriceID nvarchar 10      
UnitPriceSell pDecimal 13 0    
UnitPriceSellFgn pDecimal 13 0    
UnitCostSell pDecimal 13 0    
UnitCostSellFgn pDecimal 13 0    
PriceExt pDecimal 13 0    
PriceExtFgn pDecimal 13 0    
CostExtFgn pDecimal 13 0    
CostExt pDecimal 13 0    
PromoID nvarchar 10      
ActShipDate datetime 8      
EffectiveRate pDecimal 13 0    
OrigOrderQty pDecimal 13 0    
BinNum nvarchar 10      
ConversionFactor pDecimal 13 -1    
LottedYN bit 1 0    
InItemYN bit 1 0    
HistSeqNum int 4 0    
ExtCost pDecimal 13 0    
ExtFinalInc pDecimal 13 0    
ExtOrigInc pDecimal 13 0    
TransHistId nvarchar 10      
TaskId nvarchar 10      
PhaseName nvarchar 30      
ProjName nvarchar 30      
ExtFinalIncFgn pDecimal 13 0    
TaskName nvarchar 30      
Kit bit 1 0    
ReqShipDate datetime 8      
Rep1Id pSalesRep 3      
Rep1Pct pDecimal 13 0    
Rep1CommRate pDecimal 13 0    
Rep2Id pSalesRep 3      
Rep2Pct pDecimal 13 0    
Rep2CommRate pDecimal 13 0    
UnitCommBasis pDecimal 13 0    
UnitCommBasisFgn pDecimal 13 0    
PriceAdjType tinyint 1 0 Price Adjustment Type 0 = Amount, 1 = Percent
PriceAdjPct pDecimal 13 0    
PriceAdjAmt pDecimal 13 0    
PriceAdjAmtFgn pDecimal 13 0    
UnitPriceSellBasis pDecimal 13 0    
UnitPriceSellBasisFgn pDecimal 13 0    
BlanketDtlRef int 4      
ZeroPrint bit 1 0    
LineSeq int 4      
BOLNum varchar 17      
GrpId int 4      
KitQty pDecimal 13      
OriCompQty pDecimal 13 0    
TotQtyOrdSell pDecimal 13 0    
TotQtyShipSell pDecimal 13 0    
Status tinyint 1 0 Line Item Status 0 = Open, 1 = Completed
ResCode varchar 10      
DropShipYn bit 1 0    
CF xml -1      
ActivityType tinyint 1   Activity Type 0 = Time, 1 = Material, 2 = Expense, 3 = Other, 4 = Deposit, 5 = Deposit Applied, 6 = Fixed Fee Billing, 7 = Credit Memo
CustomerPartNumber pDescription        
*ExtLocAID nvarchar 10      
*ExtLocBID nvarchar 10      
*QtySeqNum_Ext int 4      
*QtyStatus int 4      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14 0    
CustID pCustID 10      
FinchDate datetime 8      
FinchAmt pDecimal 13 0    
GLPeriod smallint 2 0    
FiscalYear smallint 2 0    
SumHistPeriod smallint 2 -1    
CurrencyID pCurrency 6      
FinchAmtFgn pDecimal 13 0    
ExchRate pDecimal 13 -1    
GLAcctFinch pGlAcct 40      
GLAcctReceivables pGlAcct 40      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14 0    
TransId pTransID 8      
TransType smallint 2 -1 Transaction Type 1 = Invoice, -1 = Credit Memo
BatchId pBatchID 6 '######'    
CustId pCustID 10      
ShipToID nvarchar 10      
ShipToName nvarchar 30      
ShipToAddr1 nvarchar 30      
ShipToAddr2 nvarchar 60      
ShipToCity nvarchar 30      
ShipToRegion nvarchar 10      
ShipToCountry pCountry 6      
ShipToPostalCode nvarchar 10      
ShipVia nvarchar 20      
TermsCode pTermsCode 6      
TaxableYN bit 1 -1    
InvcNum pInvoiceNum 15      
CredMemNum pInvoiceNum 15      
PackNum pInvoiceNum 15      
WhseId pLocID 10      
OrderDate datetime 8      
ShipNum nvarchar 18      
ShipDate datetime 8      
InvcDate datetime 8 getdate()    
Rep1Id pSalesRep 3      
Rep1Pct pDecimal 13 0    
Rep2Id pSalesRep 3      
Rep2Pct pDecimal 13 0    
TaxOnFreight bit 1 -1    
TaxClassFreight tinyint 1 0    
TaxClassMisc tinyint 1 0    
PostDate datetime 8      
FiscalYear smallint 2      
GLPeriod smallint 2      
TaxGrpID pTaxLoc 10      
TaxSubtotal pDecimal 13 0    
NonTaxSubtotal pDecimal 13 0    
SalesTax pDecimal 13 0    
Freight pDecimal 13 0    
Misc pDecimal 13 0    
TotCost pDecimal 13 0    
TotPmtAmt pDecimal 13 0    
TaxSubtotalFgn pDecimal 13 0    
NonTaxSubtotalFgn pDecimal 13 0    
SalesTaxFgn pDecimal 13 0    
FreightFgn pDecimal 13 0    
MiscFgn pDecimal 13 0    
TotCostFgn pDecimal 13 0    
TotPmtAmtFgn pDecimal 13 0    
PrintStatus tinyint 1 0 Invoice Print Status 0 = Unprinted, 1=Online, 2 = Batch
CustPONum nvarchar 25      
DistCode pDistCode 6      
CurrencyID pCurrency 6      
ExchRate pDecimal 13 -1    
CalcGainLoss pDecimal 13 0    
TotPmtGainLoss pDecimal 13 0    
DiscDueDate datetime 8      
NetDueDate datetime 8      
DiscAmt pDecimal 13 0    
DiscAmtFgn pDecimal 13 0    
SumHistPeriod smallint 2 -1    
TaxAmtAdj pDecimal 13 0    
TaxAmtAdjFgn pDecimal 13 0    
TaxAdj tinyint 1 -1    
TaxLocAdj nvarchar 10      
TaxClassAdj tinyint 1 0    
CustLevel nvarchar 10      
PODate datetime 8      
ReqShipDate datetime 8      
PickNum nvarchar 15      
Source tinyint 1 0 Source Application 0 = AR, 1 = SO, 2 = SD, 3 = PC, 4 = PS
BillingPeriodFrom datetime 8      
PMTransType nvarchar 4      
ProjItem nvarchar 4      
BillingPeriodThru datetime 8      
BillingFormat smallint 2      
Rep1CommRate pDecimal 13 0    
Rep2CommRate pDecimal 13 0    
SoldToId pCustID 10      
BlanketRef int 4      
CF xml -1      
GLAcctFreight pGlAcct 40      
GlAcctGainLoss pGlAcct 40      
GLAcctMisc pGlAcct 40      
GLAcctReceivables pGlAcct 40      
GLAcctSalesTax pGlAcct 40      
Notes nvarchar max      
PrintOption nvarchar 510      
ReturnDirectToStockYn bit 1      
ShipToPhone varchar 24      
SourceId uniqueidentifier 16      
SourceInfo varchar 15      
VoidYn bit 1 0    
*TaxGrpID2 pTaxLoc        
*FreightTermID bigint        
*FreightTerm nvarchar 255      
*FreightAccountNumber nvarchar 255      
*DeliverySurcharge bit 1 0    
*ResidentialYN bit 1 0    
*GlobalLocationNumber nvarchar 13      
*TotalCharges pDecimal 13 0    
*ActualWeight pDecimal 13 0    
*ShipToFax nvarchar 15      
*ShipToEmail pEmail        
*NumberOfPackage Int 4      
*ReqDeliveryDate datetime 8      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
TransId pTransID 8      
SeqNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
QtyOrder pDecimal 13 0    
QtyFilled pDecimal 13 0    
QtyBkord pDecimal 13 0    
CostUnit pDecimal 13 0    
CostUnitFgn pDecimal 13 0    
HistSeqNum int 4      
Cmnt nvarchar 35      
CF xml -1      
EntryNum int        
*ExtLocAID nvarchar 10      
*ExtLocBID nvarchar 10      
*QtySeqNum_Ext int 4      
*QtyStatus int 4      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
PostRun pPostRun 14 0    
CustId pCustID 10      
TransId pTransID 8      
InvcNum pInvoiceNum 15      
Rep1Id pSalesRep 3      
Rep2Id pSalesRep 3      
CheckNum pCheckNum 10      
CcNum nnvarchar 510      
CcHolder nvarchar 30      
BankID pBankID 10      
DepNum nvarchar 25      
DistCode pDistCode 6      
PmtMethodId nvarchar 10      
CcAuth nvarchar 10      
GLRecvAcct pGlAcct 40      
PmtDate datetime 8 getdate()    
DiffDisc pDecimal 13 0    
DiffDiscFgn pDecimal 13 0    
PmtAmt pDecimal 13 0    
PmtAmtFgn pDecimal 13 0    
PmtType tinyint 1 -1 Payment Type 1 = Cash, 2 = Check, 3 = Credit Card, 4 = Write Off, 5 = Other, 6 = DirectDebit, 7 = External
GLPeriod smallint 2 0    
FiscalYear smallint 2 0    
CurrencyId pCurrency 6      
ExchRate pDecimal 13 -1    
CalcGainLoss pDecimal 13 0    
SumHistPeriod smallint 2 -1    
BankName nvarchar 30      
BankRoutingCode nvarchar 9      
BankAcctNum nnvarchar 510      
RecType tinyint 1 0 Record Type 0 = Payment, 1 = Reapplied Credit, 2 = Reapplied Payment, 3 = Prepayment
CF xml -1      
CcExpire datetime 8      
GlAcctDebit pGlAcct 40      
GlAcctGainLoss pGlAcct 40      
Note varchar 25      
PostDate datetime 8      
RecType tinyint 1      
SourceId uniqueidentifier 16      
VoidYn bit 1      
*AdjAmt pDecimal 13 0    
*AdjAmtFgn pDecimal 13 0    
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
Source tinyint 1 0 Source 0 = AR, 1 = SO
RecurId nvarchar 8      
CopyDate datetime 8      
BillDate datetime 8      
Amount pDecimal 13 0    
PostRun pPostRun 14      
TransId pTransID 8      
UserId pUserID 20      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
TransId pTransID 8      
EntryNum int 4      
SeqNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
SerNum pSerNum 35      
CostUnit pDecimal 13 0    
PriceUnit pDecimal 13 0    
CostUnitFgn pDecimal 13 0    
PriceUnitFgn pDecimal 13 0    
HistSeqNum int 4      
Cmnt nvarchar 35      
CF xml -1      
ExtLocAID varchar 10      
ExtLocBID varchar 10      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14 0    
TransId pTransID 8      
TaxLocID pTaxLoc 10      
TaxClass tinyint 1 0    
Level tinyint 1 -1    
TaxAmt pDecimal 13 0    
TaxAmtFgn pDecimal 13 0    
Taxable pDecimal 13 0    
TaxableFgn pDecimal 13 0    
NonTaxable pDecimal 13 0    
NonTaxableFgn pDecimal 13 0    
LiabilityAcct pGlAcct 40      
CF xml -1      
TaxGroupType tinyint 1 0   0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2
ExpenseAccount pGlAcct        
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
CustId pCustID 10      
InvcNum pInvoiceNum 15      
CredMemNum pInvoiceNum 15      
RecType smallint 2 -1 Invoice Record Type 1 = Invoice, 4 = Finance Charge, 5 = Pro Forma, -1 = Credit, -2 = Payment, -3 = Gain / Loss
Status tinyint 1 0 Invoice Status 0 = Rel, 1 = Hold, 4 = Paid
DistCode pDistCode 6      
TermsCode pTermsCode 6      
TransDate datetime 8 getdate()    
DiscDueDate datetime 8      
NetDueDate datetime 8      
Amt pDecimal 13 0    
AmtFgn pDecimal 13 0    
DiscAmt pDecimal 13 0    
DiscAmtFgn pDecimal 13 0    
PmtMethodId nvarchar 10      
CheckNum pCheckNum 10      
JobId nvarchar 10      
CurrencyId pCurrency 6      
ExchRate pDecimal 13 -1    
GlPeriod smallint 2 0    
FiscalYear smallint 2 0    
PhaseId nvarchar 10      
ProjId nvarchar 10      
PostRun pPostRun 14      
TransId pTransID 8      
GainLossStatus smallint 2 0    
CustPONum nvarchar 25      
SourceApp tinyint 1 0 Source Application 0 = AR, 1 = SO, 2 = SD, 3 = PC
CF xml -1      
ts timestamp 8      
*AgingPeriod tinyint 1     0 = Current, 1 = Period1(31-60), 2 = Period2(61-90), 3 = Period3(91-120), 4 = Period4(121+), 10 = FinanceCharge
*InvoiceID int 4      
*AppliedAmount pDecimal 13      
*AppliedDiscount pDecimal 13      
*GainLossAmount pDecimal 13      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
BankID pBankID 10      
TransmitDate datetime 8      
CustID pCustID 10      
CustomerName nvarchar 30      
CustomerBankName nvarchar 30      
CustomerRoutingCode nvarchar 9      
CustomerAccountNumber nnvarchar 510      
CustomerAcctType tinyint 1 0    
PaymentAmount pDecimal 13 0    
PaymentDate datetime 8      
PostRun pPostRun 14      
TransID pTransID 8      
TransactionType tinyint 1 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
PmtMethodID nvarchar 10      
Desc nvarchar 30      
PmtType smallint 2 -1 Payment Type 1 = Cash, 2 = Check, 3 = Credit Card, 4 = Write Off, 5 = Other, 6 = Direct Debit, 7 = External
GLAcctDebit pGlAcct 40      
BankId pBankID 10      
CustId pCustID 10      
OpenDrawer bit 1 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
PmtMethodID nvarchar 10      
FiscalYear smallint 2 0    
GLPeriod smallint 2 0    
Pmt pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
RecurId nvarchar 8      
EntryNum int 4      
LineSeq int 4      
CatId nvarchar 2      
TaxClass tinyint 1 0    
AcctCode pGLAcctCode 2      
GLAcctSales pGlAcct 40      
GLAcctCOGS pGlAcct 40      
GLAcctInv pGlAcct 40      
Rep1Id pSalesRep 3      
Rep1Pct pDecimal 13 0    
Rep2Id pSalesRep 3      
Rep2Pct pDecimal 13 0    
UnitCommBasis pDecimal 13 0    
CF xml -1      
ts timestamp 8      
AddnlDescr nvarchar max      
Descr varchar 35      
ItemId pItemID 24      
LocId pLocID 10      
PriceId varchar 10      
PromoId varchar 10      
Quantity pDecimal 13      
UnitCost pDecimal 13      
UnitPrice pDecimal 13      
Units pUom 5      
CustomerPartNumber pDescription        
Column Name Column Type Length Default Value Description Enumeration
RecurId nvarchar 8      
RunCode nvarchar 6      
StartingDate datetime 8      
EndingDate datetime 8      
CurrencyId pCurrency 6      
CustId pCustID 10      
ShipNum nvarchar 18      
ShipVia nvarchar 20      
TermsCode pTermsCode 6      
DistCode pDistCode 6      
TaxableYN bit 1 -1    
CustPoNum nvarchar 25      
Rep1Id pSalesRep 3      
Rep1Pct pDecimal 13 0    
Rep2Id pSalesRep 3      
Rep2Pct pDecimal 13 0    
TaxClassFreight tinyint 1 0    
TaxGrpId pTaxLoc 10      
TaxClassMisc tinyint 1 0    
Freight pDecimal 13 0    
Misc pDecimal 13 0    
TaxAmtAdj pDecimal 13 0    
TaxAdj tinyint 1 -1    
TaxLocAdj pTaxLoc 10      
TaxClassAdj tinyint 1 0    
BillType tinyint 1 0 Billing Type 0 = As Needed, 1 = Days, 2 = Monthly, 3 = Quarterly, 4 = Yearly
BillInterval int 4 0 Billing Interval 0 = Not Set, Non-Zero = Number of Intervals (Days)
NextBillDate datetime 8      
LastBillDate datetime 8      
PmtMethodId nvarchar 10      
CCNum nnvarchar 510      
CCHolder nvarchar 30      
CCExpire datetime 8      
BankName nvarchar 30      
BankAcctNum nnvarchar 510      
BankRoutingCode nvarchar 9      
CF xml -1      
ts timestamp 8      
CCAuth varchar 10      
CustLevel varchar 10      
LocId pLocID 10      
PoDate datetime 8      
RecurType tinyint 1   Recur Type 0 = Invoice, 1 = New Order
ShipToAddr1 varchar 30      
ShipToAddr2 varchar 60      
ShipToCity varchar 30      
ShipToCountry pCountry 6      
ShipToName varchar 30      
ShipToPostalCode varchar 10      
ShipToRegion varchar 10      
SoldToId pCustID 10      
ExtPmtActivityID bigint 8      
*TaxGrpID2 pTaxLoc        
*FreightTermID bigint        
*FreightAccountNumber nvarchar 255      
*DeliverySurcharge bit 1 0    
*ResidentialYN bit 1 0    
*GlobalLocationNumber nvarchar 13      
Column Name Column Type Length Default Value Description Enumeration
AcctCode pGLAcctCode 2      
Desc nvarchar 35      
GlAcctSales pGlAcct 40      
GlAcctCOGS pGlAcct 40      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
SalesRepID pSalesRep 3      
Name nvarchar 30      
Addr1 nvarchar 30      
Addr2 nvarchar 60      
City nvarchar 30      
Region nvarchar 10      
Country pCountry 6      
PostalCode nvarchar 10      
IntlPrefix nvarchar 6      
Phone nvarchar 15      
Fax nvarchar 15      
EmplId pEmpID 11      
RunCode nvarchar 10      
CommRate pDecimal 13 0    
PctOf tinyint 1 0 Commission Percentage 0 = None, 1 = Sales(Net), 2 = Gross Profit
BasedOn tinyint 1 0 Commission Basis 0 = Booked Sales, 1 = Paid Invoices
PayOnLineItems bit 1 -1    
PayOnSalesTax bit 1 0    
PayOnFreight bit 1 0    
PayOnMisc bit 1 0    
PTDSales pDecimal 13 0    
YTDSales pDecimal 13 0    
LastSalesDate datetime 8      
Email pEmail 255      
Internet pWeb 255      
PayVia tinyint 1 0 Pay Via 0 = None, 1 = Payroll, 2 = Accounts Payable
EarnCode pCode 3      
VendorId pVendorID 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
SalesRepID pSalesRep 3      
CommType tinyint 1 0 Commission Type 0 = Item ID, 1 = Product Line, 2 = Category
RefID nvarchar 24      
CommRate pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ShipMethodID nvarchar 6      
Desc nvarchar 20      
OnlineTrackYn bit 1 0    
InternetPath nvarchar 255      
HoldingCharacters nvarchar 10      
Additional1 nvarchar 50      
Additional2 nvarchar 50      
CF xml -1      
ts timestamp 8      
*ShipperID bigint 8      
*MaxContainerValue pDecimal 13      
*MaxContainerWeight pDecimal 13      
*MaxShipValue pDecimal 13      
*MaxShipWeight pDecimal 13      
Column Name Column Type Length Default Value Description Enumeration
CustId pCustID 10      
ShiptoId pCustID 10      
ShiptoName nvarchar 30      
Addr1 nvarchar 30      
Addr2 nvarchar 60      
City nvarchar 30      
Region nvarchar 10      
Country pCountry 6      
PostalCode nvarchar 10      
IntlPrefix nvarchar 6      
Phone nvarchar 15      
Fax nvarchar 15      
Attn nvarchar 30      
ShipVia nvarchar 20      
TaxLocID pTaxLoc 10      
TerrId nvarchar 10      
DistCode pDistCode 6      
Email pEmail 255      
Internet pWeb 255      
AddressType tinyint 1 0 Address Type 0 = Business, 1 = Residential
Phone1 nvarchar 15      
Phone2 nvarchar 15      
CF xml -1      
ts timestamp 8      
*TaxGrpId2 pTaxLoc        
*FreightTermID bigint 8      
*FreightAccountNumber nvarchar 255      
*DeliverySurcharge bit 1 0    
*ResidentialYN bit 1 0    
*GlobalLocationNumber nvarchar 13      
Column Name Column Type Length Default Value Description Enumeration
TermsCode pTermsCode 6      
Desc nvarchar 15      
DiscPct pDecimal 13 0    
DiscDayOfMonth bit 1 0 Discount Day of Month Yes / No Flag 0 = No, -1 = Yes
DiscDays smallint 2 0    
DiscMinDays smallint 2 0    
NetDueDays smallint 2 0    
NetDueDayOfMonth bit 1 0    
NetDueMinDays smallint 2 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TransID pTransID 8      
ItemJob tinyint 1 0 Item / Job Flag 0 = Item, 1 = Job
WhseId pLocID 10      
PartId pItemID 24      
JobId nvarchar 10      
PhaseId nvarchar 10      
JobCompleteYN bit 1 0    
EntryNum int        
Desc nvarchar 35      
LottedYn bit 1 0    
PartType tinyint 1 0 Part Type 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item, 4 = Job
AddnlDesc text 16      
CatId nvarchar 2      
TaxClass tinyint 1 0    
AcctCode pGLAcctCode 2      
GLAcctSales pGlAcct 40      
GLAcctCOGS pGlAcct 40      
GLAcctInv pGlAcct 40      
QtyOrdSell pDecimal 13 0    
UnitsSell pUom 5      
UnitsBase pUom 5      
QtyShipBase pDecimal 13 0    
QtyShipSell pDecimal 13 0    
QtyBackordSell pDecimal 13 0    
PriceCode nvarchar 10      
UnitPriceSell pDecimal 13 0    
UnitCostSell pDecimal 13 0    
UnitPriceSellFgn pDecimal 13 0    
UnitCostSellFgn pDecimal 13 0    
PriceExt pDecimal 13 0    
PriceExtFgn pDecimal 13 0    
CostExtFgn pDecimal 13 0    
CostExt pDecimal 13 0    
HistSeqNum int 4 0    
ExtCost pDecimal 13 0    
ExtFinalInc pDecimal 13 0    
ExtOrigInc pDecimal 13 0    
TransHistId nvarchar 10      
TaskId nvarchar 10      
PhaseName nvarchar 30      
ProjName nvarchar 30      
ExtFinalIncFgn pDecimal 13 0    
TaskName nvarchar 30      
QtySeqNum int 4 0    
ReqShipDate datetime 8      
Rep1Id pSalesRep 3      
Rep1Pct pDecimal 13 0    
Rep1CommRate pDecimal 13 0    
Rep2Id pSalesRep 3      
Rep2Pct pDecimal 13 0    
Rep2CommRate pDecimal 13 0    
UnitCommBasis pDecimal 13 0    
UnitCommBasisFgn pDecimal 13 0    
PriceAdjType tinyint 1 0 Price Adjustment Type 0 = Amount, 1 = Percent
PriceAdjPct pDecimal 13 0    
PriceAdjAmt pDecimal 13 0    
PriceAdjAmtFgn pDecimal 13 0    
UnitPriceSellBasis pDecimal 13 0    
UnitPriceSellBasisFgn pDecimal 13 0    
ZeroPrint bit 1 0    
LineSeq int 4      
CustomerPartNumber pDescription        
CF xml -1      
ts timestamp 8      
*ExtLocA int 4      
*ExtLocB int 4      
*QtySeqNum_Ext int 4      
*QtyStatus int 4      
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
TransType smallint 2 -1 Transaction Type 1 = Invoice, -1 = Credit Memo
VoidYn bit 1 0    
BatchId pBatchID 6 '######'    
CustId pCustID 10      
ShipToID pCustID 10      
ShipToName nvarchar 30      
ShipToAddr1 nvarchar 30      
ShipToAddr2 nvarchar 60      
ShipToCity nvarchar 30      
ShipToRegion nvarchar 10      
ShipToCountry pCountry 6      
ShipToPostalCode nvarchar 10      
ShipVia nvarchar 20      
TermsCode pTermsCode 6      
TaxableYN bit 1 -1    
InvcNum pInvoiceNum 15      
OrgInvcNum pInvoiceNum 15      
-*OrgInvcExchRate pDecimal 13 -1    
WhseId pLocID 10      
OrderDate datetime 8      
ShipNum nvarchar 18      
ShipDate datetime 8      
InvcDate datetime 8 getdate()    
Rep1Id pSalesRep 3      
Rep1Pct pDecimal 13 0    
Rep2Id pSalesRep 3      
Rep2Pct pDecimal 13 0    
TaxOnFreight bit 1 -1    
TaxClassFreight tinyint 1 0    
TaxClassMisc tinyint 1 0    
PostDate datetime 8      
GLPeriod smallint 2 0    
FiscalYear smallint 2 0    
TaxGrpID pTaxLoc 10      
TaxSubtotal pDecimal 13 0    
NonTaxSubtotal pDecimal 13 0    
SalesTax pDecimal 13 0    
Freight pDecimal 13 0    
Misc pDecimal 13 0    
TotCost pDecimal 13 0    
TaxSubtotalFgn pDecimal 13 0    
NonTaxSubtotalFgn pDecimal 13 0    
SalesTaxFgn pDecimal 13 0    
FreightFgn pDecimal 13 0    
MiscFgn pDecimal 13 0    
TotCostFgn pDecimal 13 0    
PrintStatus tinyint 1 0 Invoice Print Status 0 = Unprinted, 1=Online, 2 = Batch
CustPONum nvarchar 25      
DistCode pDistCode 6      
CurrencyID pCurrency 6      
ExchRate pDecimal 13 -1    
-*CalcGainLoss pDecimal 13 0    
DiscDueDate datetime 8      
NetDueDate datetime 8      
DiscAmt pDecimal 13 0    
DiscAmtFgn pDecimal 13 0    
-*SumHistPeriod smallint 2 -1    
TaxAmtAdj pDecimal 13 0    
TaxAmtAdjFgn pDecimal 13 0    
TaxAdj tinyint 1 -1    
TaxLocAdj pTaxLoc 10      
TaxClassAdj tinyint 1 0    
-*BillingPeriodFrom datetime 8      
-*PMTransType nvarchar 4      
-*ProjItem nvarchar 4   Item Detail / No Detail / Project Detail Flag IT = Item, NO = Unassigned, PR = Project
-*BillingPeriodThru datetime 8      
-*BillingFormat smallint 2      
Rep1CommRate pDecimal 13 0    
Rep2CommRate pDecimal 13 0    
-*CRFromHist bit 1 0    
SourceId uniqueidentifier 16      
CF xml -1      
ts timestamp 8      
*OrgInvoiceID int 4      
*TaxGrpID2 pTaxLoc        
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
EntryNum int 4      
SeqNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
QtyOrder pDecimal 13 0    
QtyFilled pDecimal 13 0    
QtyBkord pDecimal 13 0    
CostUnit pDecimal 13 0    
CostUnitFgn pDecimal 13 0    
HistSeqNum int 4      
Cmnt nvarchar 35      
QtySeqNum int 4 0    
CF xml -1      
ts timestamp 8      
*ExtLocA int 4      
*ExtLocB int 4      
*QtySeqNum_Ext int 4      
*QtyStatus int 4      
Column Name Column Type Length Default Value Description Enumeration
BankAcctNum nvarchar 510      
BankName varchar 30      
BankRoutingCode varchar 9      
CalcGainLoss pDecimal 13      
CcAuth varchar 10      
CcExpire datetime 8      
CcHolder varchar 30      
CcNum nvarchar 510      
CcSecCode varchar 6      
CheckNum pCheckNum 10      
CurrencyId pCurrency 6      
DepositId pBatchID 6      
ExchRate pDecimal 13      
FiscalYear smallint 2      
GlAcctGainLoss pGlAcct 40      
GlAcctReceivables pGlAcct 40      
GlPeriod smallint 2      
LinkId int 4      
Note varchar 25      
PmtAmt pDecimal 13      
PmtAmtFgn pDecimal 13      
PmtDate datetime 8      
PmtMethodId varchar 10      
PmtNum int 4      
PostedYn bit 1      
TransId pTransID 8      
ts timestamp 8      
CF xml -1      
ExtPmtActivityID bigint 8      
Column Name Column Type Length Default Value Description Enumeration
EntryNum int        
TransId pTransID 8      
SeqNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
SerNum pSerNum 35      
CostUnit pDecimal 13 0    
PriceUnit pDecimal 13 0    
CostUnitFgn pDecimal 13 0    
PriceUnitFgn pDecimal 13 0    
HistSeqNum int 4      
Cmnt nvarchar 35      
QtySeqNum int 4 0    
CF xml -1      
ts timestamp 8      
ExtLocA int 4      
ExtLocB int 4      
*CostUnitACV pDecimal 13      
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
TaxLocID pTaxLoc 10      
TaxClass tinyint 1 0    
Level tinyint 1 -1    
TaxAmt pDecimal 13 0    
TaxAmtFgn pDecimal 13 0    
Taxable pDecimal 13 0    
TaxableFgn pDecimal 13 0    
NonTaxable pDecimal 13 0    
NonTaxableFgn pDecimal 13 0    
LiabilityAcct pGlAcct 40      
CF xml -1      
ts timestamp 8      
TaxGroupType tinyint 1 0   0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2
ExpenseAccount pGlAcct